Tuesday, July 23, 2024

yogi_Calendar For Specified School Year Starting With Specified Month And Specified Day Of Week

 Oh Yes ... with the new school year coming up, there will be need to create and print a a calendar starting with a specified month and specified day of week

In the following I present a calendar that has been created with formulas and the calendar with automatically update as 

You input the Year, Starting Month, and Starting Day Of Week 

So 

you can create the calendar for yourself my making a copy of the spreadsheet for yourself 

Or

If there is interest, I can set up a Google Form for you to specify the Year, Starting Month and Starting Day of week and the calendar will update itself to suit your need


Saturday, December 31, 2022

It's The Time Of The Year -- Happy New Year 2023

Dear Family and Friends 

Happy New Year

Pray By Grace Of God We Will Get Over With Covid 19 Soon

I present to you a 12 Month Calendar You may want to print this just as presented Year 2023 starting with January 
or 
set it up using the formulas as presented starting with any month and any day of week
 and
 also for any other year to suit your fancy and to suit your needs 
I know some of our family and friends have different needs in that their School/Hostel/Business starts from a different month other than January -- so you can print this calendar starting with any month of the year to suit your needs.

 If there is interest in your supplying the starting month on-line I can set up a Form for you to supply the month on-line and the calendar will adjust to suit your needs 

W I T H   B E S T   W I S H E S !

Friday, December 31, 2021

It's The Time Of The Year -- Happy New Year 2022!

Dear Family and Friends 

Happy New Year

Pray By Grace Of God We Will Get Over With Covid 19 Soon

I present to you a 12 Month Calendar You may want to print this just as presented Year 2022 starting with January 
or 
set it up using the formulas as presented starting with any other month
 and
 also for any other year to suit your fancy and to suit your needs 
I know some of our family and friends have different needs in that their School/Hostel/Business starts from a different month other than January -- so you can print this calendar starting with any month of the year to suit your needs.

 If there is interest in your supplying the starting month on-line I can set up a Form for you to supply the month on-line and the calendar will adjust to suit your needs 

W I T H   B E S T   W I S H E S !

Thursday, December 31, 2020

. It's The Time Of The Year -- HAPPY NEW YEAR ! .

Dear Family and Friends

H A P P Y    N E W    YEAR !

By Grace Of God We Will Get Over With Covid Soon

I present to you a 12 Month Calendar
You may want to print this just as presented starting with January
or
set it up using the formulas as presented starting with any other month
and
also for any other year to suit your fancy and to suit your needs

I know some of our family and friends have different needs in that their School/Hostel/Business starts from a different month other than January -- so you can print this calendar starting with any month of the year to suit your needs.

If there is interest in your supplying the starting month on-line I can set up a Form for you to supply the month on-line and the calendar will adjust to suit your needs


W I T H    B E S T    W I S H E S !


Tuesday, December 31, 2019

It's The Time Of The Year -- HAPPY NEW YEAR 2020!

Dear Family and Friends

H A P P Y    N E W    YEAR !

I present to you a 12 Month Calendar
You may want to print this just as presented Year 2020 starting with January
or
set it up using the formulas as presented starting with any other month
and
also for any other year to suit your fancy and to suit your needs

W I T H    B E S T    W I S H E S !


Wednesday, April 17, 2019

Sunday, March 31, 2019

yogi_Conditionally Format Columnas A2:E If Date In Column A Is Over 13 Months Old

Google Spreadsheet   Post  #2592

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Mar-31-2019
question by: Tico
https://support.google.com/docs/thread/3351311?hl=en
Conditinally format entire row, based off of an "expiration date"
Is there a way to use conditional formatting to recolor an entire row if a cell filled in with a date in the corresponding row is more than a year old

For example,

Cell A1 is marked with a date. The rest of the row (A2:A10) are filled in with several other pieces of information assosiated with that date. I need to set it so that if the date in A1 is more than 13 months old ("expires") that the entire row will shade in. 

I know I can do this setting up a cell to be a "variable" but I would like to do this WITHOUT making another cell. This document will be going live on several business servers and I would like to keep it clean (and the less things people can mess up the better haha)

I am not sure if I am making any sense here... So I also made a test document to try and re explain what I am trying to get done here.


thank you all for your help!!!