I have a spreadsheet that I use for scheduling due dates which i would like it to automatically update according to the spreadsheet date .
Can someone please help me with formulas to calculate the following:
Monthly due date - The payment date needs to be 7th of the month. I need the month to update according to the date of the spreadsheet.
Quarterly date due - The payment date needs to update to be either 25th of Aug, Nov, Feb and May according to the spreadsheet date
Quarterly date due- The payment date needs to update to occur on the following dates - 15th of Jan, April, July and Oct according to the spreadsheet date
Thanks
Can someone please help me with formulas to calculate the following:
Monthly due date - The payment date needs to be 7th of the month. I need the month to update according to the date of the spreadsheet.
Quarterly date due - The payment date needs to update to be either 25th of Aug, Nov, Feb and May according to the spreadsheet date
Quarterly date due- The payment date needs to update to occur on the following dates - 15th of Jan, April, July and Oct according to the spreadsheet date
Thanks