ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Conditional formula for dates (https://www.excelbanter.com/excel-worksheet-functions/266645-conditional-formula-dates.html)

klaesser
Conditional formula for dates
 
In my spreadsheet for expenses I have a cell for balance at end of month and have another for beginning balance for following month. I put in the formula beginning balance =ending balance but all beginning balances for year are filled for the entire year but I only want a monthly begin balance to show only if we have reached that particular month otherwise be blank or show zero

Can anyone help this poor old soul

Thanks for any tips

klaesser
Quote:
Originally Posted by klaesser (Post 960433)
In my spreadsheet for expenses I have a cell for balance at end of month and have another for beginning balance for following month. I put in the formula beginning balance =ending balance but all beginning balances for year are filled for the entire year but I only want a monthly begin balance to show only if we have reached that particular month otherwise be blank or show zero

Can anyone help this poor old soul

Thanks for any tips
I found this to work
A3 -- =IF(TODAY()=A1,A2,"")


All times are GMT +1. The time now is 12:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com