J james Apr 25, 2008 #1 I have a number of days and I want excel to automatically calculate the date of the first day. Hope I can be helped
I have a number of days and I want excel to automatically calculate the date of the first day. Hope I can be helped
P Pete_UK Apr 25, 2008 #2 Do you mean so many days before today's date? If so, then with your number of days in A1 you can use: =TODAY()-A1 Format the cell as a date in your preferred style. Hope this helps. Pete
Do you mean so many days before today's date? If so, then with your number of days in A1 you can use: =TODAY()-A1 Format the cell as a date in your preferred style. Hope this helps. Pete
