Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates
I need to get my spreadsheet to automatically update dates
for when bills were last paid - Note: I've already got the 'Todays Date' column to auto update with =NOW() ie, Item Date Last Paid Todays Date Mortgage 06/08/03 22/08/03 If I came back into spreadshee in say, 3 weeks time on 12 Sept, the todays date will auto read 12/09/03, but what can I do to get the Date Last Paid to automatically read the latest date paid, ie 06/09/03 Anybody got any ideas? Please help!! Kind regards, Gina |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates
Gina,
If it's always the 6th of the month, you could try =DATE(YEAR(TODAY()),MONTH(TODAY()),6) -- HTH ------- Bob Phillips ... looking out across Poole Harbour to the Purbecks "Gina" wrote in message ... I need to get my spreadsheet to automatically update dates for when bills were last paid - Note: I've already got the 'Todays Date' column to auto update with =NOW() ie, Item Date Last Paid Todays Date Mortgage 06/08/03 22/08/03 If I came back into spreadshee in say, 3 weeks time on 12 Sept, the todays date will auto read 12/09/03, but what can I do to get the Date Last Paid to automatically read the latest date paid, ie 06/09/03 Anybody got any ideas? Please help!! Kind regards, Gina |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking computer dates (time) to spreadsheet dates that have formu | Excel Worksheet Functions | |||
Stop dates from showing as numbers - when formated as dates | Excel Discussion (Misc queries) | |||
compare 2 tables of dates to find the preceding dates | Excel Worksheet Functions | |||
Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel |