Hi, I am doing a calender for an autoclave and I need expiry dates inserting into the next cell that is 28 days later in the format 28-Jan-17
e.g. 1st January next cell below I need 29 Jan-17, 2nd January next cell below 30-Jan-17 and so on.
Is this the first date in the sequence that you have entered manually. If so then you need to format the data in the cell to Date as hastelloy said, after that the function =A1+28 will automatically increment the second cell to the date 28 days later.
I Know, I am in the process of doing that now, that is why I am asking, I know it probably isn't possible, having the 2 differant date formats, but I thought it was worth a try,The old one was made with merged cells .
The only way around it that I can think of is to change the format of the manual number date in the large white cell to a date format DD this will continue to display just a date as you have at the moment but would require all the dates to be reentered in DD/MM/YY format for the formula to work in the grey background cells.
I set the Row Height to 50 on Rows 2, 4, 6, 8, 10, 12 and 14.
I shaded grey the odd rows, then unshaded Column A
Column B formatted to Custom Date ddmmmyy. I did this so that I could check the dates were correct. (The even rows can be selected at end and formatted to Custom Date d)
Did not need to format rest of columns C to BB as they get copied across
I only needed to make entries in columns A (Weekdays), column B (as per pic), and cell C2
In B2 I typed 30/12/2016 and the rest of Formulas as per pic (to show formatting hold down Ctrl and press ` (top left of keyboard) repeat to unshow formatting)
The rest were able to be copied across by:
selecting the cell in C2 and then dragging the + at bottom right across the row to whatever column you want. (You haven't said whether each set is for a month or wants to go right across to column BB to 29 Dec 2017)
selecting B3 and then dragging the + at bottom right across the row to whatever column you want.